home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / vbpmoneydet.sql < prev    next >
Text File  |  2000-05-12  |  974b  |  33 lines
  1. /*
  2. shows the detail for the accepted cash for a probe and particular cashbox together
  3. with the total of the cash accepted since the change of cashbox. ( cscurcnt)
  4. */
  5. CREATE OR REPLACE VIEW VBPMONEYDET  AS 
  6. select vsumcscurcnt.conversion_num,
  7. vsumcscurcnt.close_count,
  8. vsumcscurcnt.cashbox_glid,
  9. vsumcscurcnt.totalcash,
  10. vcuraccdetail.probedcash,
  11. vcuraccdetail.cents_$,
  12. vcuraccdetail.nickels_$,
  13. vcuraccdetail.dimes_$,
  14. vcuraccdetail.quarters_$,
  15. vcuraccdetail.halfs_$,
  16. vcuraccdetail.sbas_$,
  17. vcuraccdetail.cents_$ +vcuraccdetail.nickels_$ +
  18. vcuraccdetail.dimes_$ + vcuraccdetail.quarters_$ +
  19. vcuraccdetail.halfs_$ +
  20. vcuraccdetail.sbas_$ coin_total,
  21. vcuraccdetail.ones_$,
  22. vcuraccdetail.fives_$,
  23. vcuraccdetail.tens_$,
  24. vcuraccdetail.twenties_$,
  25. vcuraccdetail.ones_$ +
  26. vcuraccdetail.fives_$+
  27. vcuraccdetail.tens_$ +
  28. vcuraccdetail.twenties_$ bill_total
  29. from vsumcscurcnt, vcuraccdetail
  30. where vsumcscurcnt.close_count = vcuraccdetail.close_count (+);
  31.  
  32.  
  33.